CS13 - Oracle 10g

  • Bangalore Central Campus
  • Open From :
  • Open Until :

CS13 Oracle 10g

Teaching Hours : 60  [ 30 hours Theory + 30 hours LAB ]

Prerequisite: :  any background

Unit I

  1. Content Outline:  Introduction to Database Concepts  ,Users of Oracle,  The Relational Database Model, The Development Life Cycle ,Data Normalization , Overview of Normalization ,The Normal Forms , Logical Design , Data Modeling , Entities and Attributes , Entities and Their Relationships

(5 hours)

Unit II

  1. Introduction to Structured Query Language ,Introduction to SQL*Plus , The SELECT Statement
  2. Data Definition Language (DDL) ,Data Control Language (DCL) , Data Manipulation Language (DML) ,Transaction Control Language (TCL) ,

(8 hours)

Unit III

  1. Procedural Language / Structured Query Language ,Overview of PL/SQL , Stored Packages, Procedures,  and Functions Triggers Database Objects Datablocks Database Storage

(7 hours)

Unit IV

  1. Forms and reports     

(5 hours)

Unit V

  1. Oracle and Object-oriented Methodology  Oracle Architecture  The Oracle Database  The Oracle Instance  Accessing the Database  Other Oracle Products and Tools

(5 hours)

Text book:

  1. Kevin Loney, Oracle Database 10g: The Complete Reference, Mc-Graw Hill Osborne media, 2004.

 

Reference Book:

  1. Ian Abramson , Michael Abbey, Michael J Corey, Oracle Database 10g: A beginners guide, Mc-Graw Hill Osborne media, 2004.

  Lab programs

SQL

  1. Demonstrate the DDL commands
  2. Demonstrate the DML commands
  3. Demonstrate the DCL  commands
  4. Demonstrate the TCL  commands
  5. Demonstrate the Single line functions
  6. Demonstrate the Multiline functions
  7. Demonstrate the Join  commands
  8. Demonstrate the Inner  Join  commands
  9. Demonstrate the outer Join  commands
  10. Demonstrate the subqueries

PL/SQL

  1.  Demonstration of simple programs
  2.  Demonstration of  Cursors
  3.  Demonstration of  Triggers
  4.  Demonstration of  Packages
  5.  Demonstration of  functions
  6.  Development of a mini project using forms and reports
For any queries at any given time during the application and admission process, you may contact us through the following Email ID’s:
 
Bangalore Central Campus
The Office of Admissions,
CHRIST (Deemed to be University), Hosur Road,
Bengaluru - 560 029, Karnataka, INDIA
Ph. No: +91 92430 80800
Ph. No:  +91 80 4012 9400
 
Email IDs
Indian candidates: admissions@christuniversity.in
Bangalore Bannerghatta Road Campus
CHRIST (Deemed to be University)
Hulimavu, Bannerghatta Road,
Bengaluru - 560 076, Karnataka, INDIA
 
Ph. No:  080 4655 1306
Email:
 admissions.bgr@christuniversity.in
Bangalore Kengeri Campus
CHRIST (Deemed to be University)
Kanmanike, Kumbalgodu, Mysore Road,
Bengaluru - 560 074, Karnataka, INDIA

Ph. No:  +91 80 4012 9800, 9802, 9820
Email:
 admissions.kengeri@christuniversity.in
Bangalore Yeshwanthpur Campus
CHRIST (Deemed to be University)
Nagasandra, Near Tumkur Road,
Bengaluru 560 073, Karnataka, INDIA

Ph. No:  +91 97422 44407
Email: 
admissions.yeshwanthpur@christuniversity.in
Delhi NCR Campus
CHRIST (Deemed to be University),
Mariam Nagar, Meerut Road,
Delhi NCR Ghaziabad - 201003
 
Ph. No: 1800-123-3212
Pune Lavasa Campus
CHRIST (Deemed to be University),
Christ University Road, 30 Valor Court,
PO Dasve Lavasa, Mulshi, Pune - 412112, Maharashtra
 
Ph. No : 1800-123-2009,
Email:
 admission.lavasa@christuniversity.in
Between: Monday to Friday: 09:00 AM to 04:00 PM, Saturday: 09:00 AM to 12:00 PM
(Office remains closed on Sundays, Government Holidays and Any special events)

CHRIST UNIVERSITY

(Deemed to be University)

Dharmaram College Post, Hosur Road, Bengaluru - 560029,
Karnataka, India

Tel: +91 804012 9100 / 9600

Fax: 40129000

Email: mail@christuniversity.in

Web: http://www. christuniversity.in

Vision

EXCELLENCE AND SERVICE

Mission

CHRIST (Deemed to be University) is a nurturing ground for an individual's holistic development to make effective contribution to the society in a dynamic environment.



Copyright © CHRIST (Deemed to be University) 2020